﻿<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="viewProductDelete.aspx.cs" Inherits="Pc_Vision.View_Datalayer.viewProductDelete" %>

<%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %>


<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
    <title></title>

       <!-- #include file="load.aspx" -->
</head>
<body>
    <!-- #include file="header.aspx" -->

    <form id="form1" runat="server">
        <telerik:RadScriptManager ID="RadScriptManager1" runat="server">

            <Scripts>
                <asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.Core.js">
                </asp:ScriptReference>
                <asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.jQuery.js">
                </asp:ScriptReference>
                <asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.jQueryInclude.js">
                </asp:ScriptReference>
            </Scripts>
        </telerik:RadScriptManager>
        <telerik:RadWindowManager ID="RadWindowManager1" runat="server"></telerik:RadWindowManager>
        <telerik:RadGrid ID="RadGrid1" runat="server" CellSpacing="0" DataSourceID="SqlDataSource1" GridLines="None" OnDeleteCommand="RadGrid1_DeleteCommand" AllowSorting="True" OnNeedDataSource="RadGrid1_NeedDataSource">
            <ExportSettings>
                <Pdf PageWidth="">
                </Pdf>
            </ExportSettings>
            <ClientSettings>
                <Selecting AllowRowSelect="True" />
                <Scrolling AllowScroll="True" UseStaticHeaders="True" />
            </ClientSettings>
            <MasterTableView AutoGenerateColumns="False" DataSourceID="SqlDataSource1">
            </MasterTableView>
        </telerik:RadGrid>
       
        <asp:SqlDataSource ID="SqlDataSource5" runat="server"></asp:SqlDataSource>
        <asp:SqlDataSource ID="SqlDataSource4" runat="server" ConflictDetection="CompareAllValues" ConnectionString="<%$ ConnectionStrings:pcvisionConnectionString3 %>" DeleteCommand="DELETE FROM [product] WHERE [Artikelnummer] = ? AND [Productnaam] = ? AND [Inkoopprijs] = ? AND [Verkoopprijs] = ? AND [Opvoorraad] = ? AND [Productomschrijving] = ? AND [Systeemtype] = ? AND [Processor] = ? AND [Geheugen] = ? AND [Opslag] = ? AND [Optischeschijf] = ? AND [Display] = ? AND [Videokaart] = ? AND [Netwerkkaart] = ? AND [Batterij] = ? AND [Afmetingen] = ? AND [Gewicht] = ? AND [Garantie] = ? AND [Actieprijs] = ? AND [Rating] = ? AND (([productcol] = ?) OR ([productcol] IS NULL AND ? IS NULL))" InsertCommand="INSERT INTO [product] ([Artikelnummer], [Productnaam], [Inkoopprijs], [Verkoopprijs], [Opvoorraad], [Productomschrijving], [Systeemtype], [Processor], [Geheugen], [Opslag], [Optischeschijf], [Display], [Videokaart], [Netwerkkaart], [Batterij], [Afmetingen], [Gewicht], [Garantie], [Actieprijs], [Rating], [productcol]) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)" OldValuesParameterFormatString="original_{0}" ProviderName="<%$ ConnectionStrings:pcvisionConnectionString3.ProviderName %>" SelectCommand="SELECT * FROM [product]" UpdateCommand="UPDATE [product] SET [Productnaam] = ?, [Inkoopprijs] = ?, [Verkoopprijs] = ?, [Opvoorraad] = ?, [Productomschrijving] = ?, [Systeemtype] = ?, [Processor] = ?, [Geheugen] = ?, [Opslag] = ?, [Optischeschijf] = ?, [Display] = ?, [Videokaart] = ?, [Netwerkkaart] = ?, [Batterij] = ?, [Afmetingen] = ?, [Gewicht] = ?, [Garantie] = ?, [Actieprijs] = ?, [Rating] = ?, [productcol] = ? WHERE [Artikelnummer] = ? AND [Productnaam] = ? AND [Inkoopprijs] = ? AND [Verkoopprijs] = ? AND [Opvoorraad] = ? AND [Productomschrijving] = ? AND [Systeemtype] = ? AND [Processor] = ? AND [Geheugen] = ? AND [Opslag] = ? AND [Optischeschijf] = ? AND [Display] = ? AND [Videokaart] = ? AND [Netwerkkaart] = ? AND [Batterij] = ? AND [Afmetingen] = ? AND [Gewicht] = ? AND [Garantie] = ? AND [Actieprijs] = ? AND [Rating] = ? AND (([productcol] = ?) OR ([productcol] IS NULL AND ? IS NULL))">
            <DeleteParameters>
                <asp:Parameter Name="original_Artikelnummer" Type="String" />
                <asp:Parameter Name="original_Productnaam" Type="String" />
                <asp:Parameter Name="original_Inkoopprijs" Type="String" />
                <asp:Parameter Name="original_Verkoopprijs" Type="String" />
                <asp:Parameter Name="original_Opvoorraad" Type="Object" />
                <asp:Parameter Name="original_Productomschrijving" Type="String" />
                <asp:Parameter Name="original_Systeemtype" Type="String" />
                <asp:Parameter Name="original_Processor" Type="String" />
                <asp:Parameter Name="original_Geheugen" Type="String" />
                <asp:Parameter Name="original_Opslag" Type="String" />
                <asp:Parameter Name="original_Optischeschijf" Type="String" />
                <asp:Parameter Name="original_Display" Type="String" />
                <asp:Parameter Name="original_Videokaart" Type="String" />
                <asp:Parameter Name="original_Netwerkkaart" Type="String" />
                <asp:Parameter Name="original_Batterij" Type="String" />
                <asp:Parameter Name="original_Afmetingen" Type="String" />
                <asp:Parameter Name="original_Gewicht" Type="String" />
                <asp:Parameter Name="original_Garantie" Type="String" />
                <asp:Parameter Name="original_Actieprijs" Type="String" />
                <asp:Parameter Name="original_Rating" Type="String" />
                <asp:Parameter Name="original_productcol" Type="String" />
                <asp:Parameter Name="original_productcol" Type="String" />
            </DeleteParameters>
            <InsertParameters>
                <asp:Parameter Name="Artikelnummer" Type="String" />
                <asp:Parameter Name="Productnaam" Type="String" />
                <asp:Parameter Name="Inkoopprijs" Type="String" />
                <asp:Parameter Name="Verkoopprijs" Type="String" />
                <asp:Parameter Name="Opvoorraad" Type="Object" />
                <asp:Parameter Name="Productomschrijving" Type="String" />
                <asp:Parameter Name="Systeemtype" Type="String" />
                <asp:Parameter Name="Processor" Type="String" />
                <asp:Parameter Name="Geheugen" Type="String" />
                <asp:Parameter Name="Opslag" Type="String" />
                <asp:Parameter Name="Optischeschijf" Type="String" />
                <asp:Parameter Name="Display" Type="String" />
                <asp:Parameter Name="Videokaart" Type="String" />
                <asp:Parameter Name="Netwerkkaart" Type="String" />
                <asp:Parameter Name="Batterij" Type="String" />
                <asp:Parameter Name="Afmetingen" Type="String" />
                <asp:Parameter Name="Gewicht" Type="String" />
                <asp:Parameter Name="Garantie" Type="String" />
                <asp:Parameter Name="Actieprijs" Type="String" />
                <asp:Parameter Name="Rating" Type="String" />
                <asp:Parameter Name="productcol" Type="String" />
            </InsertParameters>
            <UpdateParameters>
                <asp:Parameter Name="Productnaam" Type="String" />
                <asp:Parameter Name="Inkoopprijs" Type="String" />
                <asp:Parameter Name="Verkoopprijs" Type="String" />
                <asp:Parameter Name="Opvoorraad" Type="Object" />
                <asp:Parameter Name="Productomschrijving" Type="String" />
                <asp:Parameter Name="Systeemtype" Type="String" />
                <asp:Parameter Name="Processor" Type="String" />
                <asp:Parameter Name="Geheugen" Type="String" />
                <asp:Parameter Name="Opslag" Type="String" />
                <asp:Parameter Name="Optischeschijf" Type="String" />
                <asp:Parameter Name="Display" Type="String" />
                <asp:Parameter Name="Videokaart" Type="String" />
                <asp:Parameter Name="Netwerkkaart" Type="String" />
                <asp:Parameter Name="Batterij" Type="String" />
                <asp:Parameter Name="Afmetingen" Type="String" />
                <asp:Parameter Name="Gewicht" Type="String" />
                <asp:Parameter Name="Garantie" Type="String" />
                <asp:Parameter Name="Actieprijs" Type="String" />
                <asp:Parameter Name="Rating" Type="String" />
                <asp:Parameter Name="productcol" Type="String" />
                <asp:Parameter Name="original_Artikelnummer" Type="String" />
                <asp:Parameter Name="original_Productnaam" Type="String" />
                <asp:Parameter Name="original_Inkoopprijs" Type="String" />
                <asp:Parameter Name="original_Verkoopprijs" Type="String" />
                <asp:Parameter Name="original_Opvoorraad" Type="Object" />
                <asp:Parameter Name="original_Productomschrijving" Type="String" />
                <asp:Parameter Name="original_Systeemtype" Type="String" />
                <asp:Parameter Name="original_Processor" Type="String" />
                <asp:Parameter Name="original_Geheugen" Type="String" />
                <asp:Parameter Name="original_Opslag" Type="String" />
                <asp:Parameter Name="original_Optischeschijf" Type="String" />
                <asp:Parameter Name="original_Display" Type="String" />
                <asp:Parameter Name="original_Videokaart" Type="String" />
                <asp:Parameter Name="original_Netwerkkaart" Type="String" />
                <asp:Parameter Name="original_Batterij" Type="String" />
                <asp:Parameter Name="original_Afmetingen" Type="String" />
                <asp:Parameter Name="original_Gewicht" Type="String" />
                <asp:Parameter Name="original_Garantie" Type="String" />
                <asp:Parameter Name="original_Actieprijs" Type="String" />
                <asp:Parameter Name="original_Rating" Type="String" />
                <asp:Parameter Name="original_productcol" Type="String" />
                <asp:Parameter Name="original_productcol" Type="String" />
            </UpdateParameters>
        </asp:SqlDataSource>
        <asp:SqlDataSource ID="SqlDataSource3" runat="server"></asp:SqlDataSource>
        <asp:SqlDataSource ID="SqlDataSource2" runat="server"></asp:SqlDataSource>
       
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:pcvisionConnectionString %>" ProviderName="<%$ ConnectionStrings:pcvisionConnectionString.ProviderName %>" SelectCommand="SELECT * FROM pcVision.product"></asp:SqlDataSource>
       
    <div>
    
    </div>
    </form>
</body>
</html>

